﻿// RankingSejmowy 1.0 - Polish parliment statistics for the masses.
// Copyright (C) 2010 Jarosław Dubrownik
//  
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
//  
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//  
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
using System.Linq;
using NHibernate;
using NHibernate.Criterion;
using RankingSejmowy.Model;

namespace RankingSejmowy.DAL.Cadences
{
    public class CadenceRepository : Repository<Cadence>, ICadenceRepository
    {
        #region ICadenceRepository Members

        public Cadence GetLastCadence(ISession session)
        {
            var criteria = CreateCriteria(session)
                .AddOrder(Order.Desc("CadenceNum"));
            return criteria.List<Cadence>().FirstOrDefault();
        }

        public Cadence GetByCadenceNum(int cadenceNum, ISession session)
        {
            var criteria = CreateCriteria(session)
                .SetFetchMode("PartyCadences", FetchMode.Eager)
                //.SetFetchMode("Meetings", FetchMode.Eager)
                .SetFetchMode("PartyCadences.Deputies", FetchMode.Eager)
                .SetFetchMode("PartyCadences.Party", FetchMode.Eager)
                .Add(Restrictions.Eq("CadenceNum", cadenceNum));
            return criteria.List<Cadence>().FirstOrDefault();
        }

        public Meeting GetCadenceLastMeeting(int cadenceNum, ISession session)
        {
            var criteria = session.CreateCriteria<Meeting>()
                .CreateAlias("Cadence", "c")
                .AddOrder(Order.Desc("MeetingNum"))
                .Add(Restrictions.Eq("c.CadenceNum", cadenceNum));

            return criteria.List<Meeting>().FirstOrDefault();
        }

        #endregion
    }
}